﻿CREATE TABLE [dbo].[UserProfiles] (
    [UserProfileID]                INT           NOT NULL,
    [FirstName]                    NVARCHAR (50) NULL,
    [LastName]                     NVARCHAR (50) NULL,
    [Birthday]                     DATETIME      NULL,
    [Gender]                       BIT           NULL,
    [Age]                          INT           NULL,
    [CurrentWeight]                INT           NULL,
    [Height]                       INT           NULL,
    [TotalCalorieLostGainPerDay]   FLOAT         NULL,
    [TotalCalorieLoseGainPerMonth] FLOAT         NULL,
    [BMI]                          FLOAT         NULL,
    [WeightCategoryID]             INT           NULL,
    [BMR]                          FLOAT         NULL,
    [ActivityLevelID]              INT           NULL,
    [HealthRatingID]               INT           NULL,
    [TotalCalorieNeedPerDay]       FLOAT         NULL,
    [TargetWeight]                 FLOAT         NULL,
    [DateTimeAdded]                DATETIME      NOT NULL,
    [DateTimeUpdated]              DATETIME      NOT NULL
);

